﻿<?xml version="1.0" encoding="UTF-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="Ribbon_Load">
  <ribbon>
    <tabs>
      <tab id ="Quick.Tab" label="Quick Excel" keytip="Q">

        <!-- G R O U P -->
        <group id="Quick.formula" label="Formulas">

          <menu id="Quick.f1" label="Text" imageMso="FunctionsTextInsertGallery" size="large" keytip="MF">
            <button id="CHAR2" label="CHAR2" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="CODE2" label="CODE2" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="CONTAINS" label="CONTAINS" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="DOLLARTEXT" label="DOLLARTEXT" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="EXTRACTELEMENT" label="EXTRACTELEMENT" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="INSERTSTRING" label="INSERTSTRING" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="ISLIKE" label="ISLIKE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="REMOVESPACES" label="REMOVESPACES" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SayIt" label="SayIt" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SCRAMBLE" label="SCRAMBLE" imageMso="FunctionWizard" onAction="QE_Functions" />

          </menu>

          <separator id="sep1" />

          <menu id="Quick.f2" label="Maths and LookUp" imageMso="FunctionsMathTrigInsertGallery" size="large" keytip="MF">
            <button id="COUNTAVISIBLE" label="COUNTAVISIBLE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="COUNTBETWEEN" label="COUNTBETWEEN" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="CREDITCARD" label="CREDITCARD" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="LASTINCOLUMN" label="LASTINCOLUMN" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="LASTINROW" label="LASTINROW" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="MAXALLSHEETS" label="MAXALLSHEETS" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="MINALLSHEETS" label="MINALLSHEETS" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SELECTONE" label="SELECTONE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SHEETOFFSET" label="SHEETOFFSET" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="STATICRAND" label="STATICRAND" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SUMALLSHEETS" label="SUMALLSHEETS" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SUMVISIBLE" label="SUMVISIBLE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="UNIQUEITEMS" label="UNIQUEITEMS" imageMso="FunctionWizard" onAction="QE_Functions" />
          </menu>

          <separator id="sep2" />
          <menu id="Quick.f3" label="Information" imageMso="FunctionsLookupReferenceInsertGallery" size="large" keytip="MF">
            <button id="CELLCOLOR" label="CELLCOLOR" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="CELLHASFORMULA" label="CELLHASFORMULA" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="CELLTYPE" label="CELLTYPE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="EXCELDIR" label="EXCELDIR" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="FILEEXISTS" label="FILEEXISTS" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="FILENAME" label="FILENAME" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="FONTCOLOR" label="FONTCOLOR" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="NUMBERFORMAT" label="NUMBERFORMAT" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SHEETCOUNT" label="SHEETCOUNT" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="SHEETNAME" label="SHEETNAME" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="USER" label="USER" imageMso="FunctionWizard" onAction="QE_Functions" />
          </menu>

          <separator id="sep3" />
          <menu id="Quick.9" label="Date and Time" imageMso="FunctionsDateTimeInsertGallery" size="large" keytip="MF">
            <button id="DAYSINMONTH" label="DAYSINMONTH" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="MONTHWEEK" label="MONTHWEEK" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="WHICHDAY" label="WHICHDAY" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATE" label="XDATE" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEADD" label="XDATEADD" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEDAY" label="XDATEDAY" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEDIF" label="XDATEDIF" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEDOW" label="XDATEDOW" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEMONTH" label="XDATEMONTH" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEYEAR" label="XDATEYEAR" imageMso="FunctionWizard" onAction="QE_Functions" />
            <button id="XDATEYEARDIF" label="XDATEYEARDIF" imageMso="FunctionWizard" onAction="QE_Functions" />
          </menu>         
        </group>

        <group id="Quick.CellsAndRanges" label="Cells and Ranges">
          <menu id="Quick.22" label="Format" imageMso="ViewBackToColorView" size="large" keytip="T">
            <button id="AlternateRowShading" label="Alternate Row Shading..."  imageMso="TableRowSelect" onAction="AlternateRowShading" />
            <button id="DeleteHyperlink" label="Delete Hyperlink" imageMso="_3DExtrusionDepth288Classic" onAction="RibbonCallback" />
          </menu>

          <menu id="Quick.18" label="Convert" imageMso="ListSynchronize" size="large" keytip="V">
            <button id="UnitConversion" label="Unit Conversion..." imageMso="SetPertWeights" onAction="UnitConversion" />
            <button id="CurrencyConversion" label="Currency Conversion..." imageMso="DollarSign" onAction="CurrencyConversion" />
          </menu>

          <menu id="Quick.41" label="Select" imageMso="TableRowsInsertBelowWord" size="large" keytip="L">
            <button id="SelectbyValue" label="Select by Value..." imageMso="ListSetNumberingValue" onAction="SelectByVal" />
            <button id="SelectbyFormat" label="Select by Format..." imageMso="PivotTableEnableSelection" onAction="SelectByFormat" />
            <menuSeparator id="sep1.332" />
            <button id="GoToMinorMaxValue" label="Go To Min or Max Value..." imageMso="GoToNewRecord" onAction="MinOrMax" />
          </menu>
        </group>



        <group id="Quick.calendar" label="Calendar">
          <button id="InsertCalendarRange" label="Insert A Live Calendar..." imageMso="CopyToPersonalCalendar" size="large" onAction="RibbonCallback" />
          <button id="DatePickerToolbar" label="Date Picker..." imageMso="DateAndTimeInsert" onAction="datePick" size="large" />

        </group>
        <!-- G R O U P -->
        <group id="Quick.ExportImport" label="Import and Export">

          <button id="ExportRangetoFile" label="Export Range to File..." imageMso="PivotExportToExcel" onAction="ExportRangetoFile" />
          <button id="ExportRangeasGraphic" label="Export Range as Graphic..." imageMso="Camera" onAction="ExportRangeAsGraphic" />
          <button id="ImportFileatCursor" label="Import File at Cursor" imageMso="ImportExcel" onAction="ImportFileAtCursor" />
        </group>

        <!-- G R O U P -->
        <group id="Quick.Charts" label="Charts Tools">
          <button id="ExportCharts" label="Export Charts..." imageMso="ChartStylesGallery" onAction="exportChart" />
          <button id="ResizeCharts" label="Resize Charts..." imageMso="AdpDiagramAutosizeSelectedTables" onAction="resizechart" />
          <button id="ConvertCharttoPicture" label="Convert Chart to Picture..." imageMso="PicturePositionGallery" onAction="chartToPic" />
        </group>


        <!-- G R O U P -->
        <group id="Quick.Bookmarks" label="Bookmarks">
          <button id="BookmarksCreate" size="normal" label="Create a Bookmark" imageMso="FrontPageToggleBookmark"  onAction="createbookmark" keytip="B"/>
          <button id="BookmarksEdit" size="normal" label="Edit Bookmarks" imageMso="FunctionsDateTimeInsertGallery" onAction="editbookmark" keytip="E"/>
          <button id="BookmarksList" size="normal" label="Activate Bookmark" imageMso="FormulaMoreFunctionsMenu" onAction="applybookmark" keytip="A"/>
        </group>


        <!-- G R O U P -->
        <group id="Quick.Tools" label="Tools">

          <button id="ToggleSettings" label="Toggle Settings"  imageMso="ActiveXToggleButton" onAction="ToggleSettings" />          
          <button id="SortSheet" label="Sort Sheets" imageMso="SheetInsert" onAction="sortsheet" />

        </group>

        <group id="Quick.About" label="About">

          <button id="About" label="About Quick Excel"  imageMso="PropertySheet" size="large" onAction="RibbonCallback" />

        </group>

      </tab>
    </tabs>
  </ribbon>
</customUI>

